Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	105666
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	12.1 MiB
Average record size in memory	120.0 B

Variable types

Categorical	4
Numeric	11

Alerts

`Province` has a high cardinality: 90 distinct values	High cardinality
`City` has a high cardinality: 1441 distinct values	High cardinality
`Barangay` has a high cardinality: 26279 distinct values	High cardinality
`DOMAGOSO, ISKO MORENO (AKSYON)` is highly correlated with `LACSON, PING (PDR)`	High correlation
`LACSON, PING (PDR)` is highly correlated with `DOMAGOSO, ISKO MORENO (AKSYON)`	High correlation
`Province` is highly correlated with `Region`	High correlation
`Region` is highly correlated with `Province`	High correlation
`Region` is highly correlated with `Province` and 3 other fields	High correlation
`Province` is highly correlated with `Region` and 6 other fields	High correlation
`Precinct ID` is highly correlated with `Region` and 1 other fields	High correlation
`DOMAGOSO, ISKO MORENO (AKSYON)` is highly correlated with `Province`	High correlation
`MANGONDATO, FAISAL (KTPNAN)` is highly correlated with `Province`	High correlation
`MARCOS, BONGBONG (PFP)` is highly correlated with `Region` and 2 other fields	High correlation
`PACQUIAO, MANNY PACMAN(PROMDI)` is highly correlated with `Province`	High correlation
`ROBREDO, LENI (IND)` is highly correlated with `Region` and 2 other fields	High correlation
`GONZALES, NORBERTO (PDSP)` is highly skewed (γ1 = 40.24535664)	Skewed
`Precinct ID` has unique values	Unique
`ABELLA, ERNIE (IND)` has 47643 (45.1%) zeros	Zeros
`DE GUZMAN, LEODY (PLM)` has 50828 (48.1%) zeros	Zeros
`DOMAGOSO, ISKO MORENO (AKSYON)` has 4429 (4.2%) zeros	Zeros
`GONZALES, NORBERTO (PDSP)` has 52143 (49.3%) zeros	Zeros
`LACSON, PING (PDR)` has 9080 (8.6%) zeros	Zeros
`MANGONDATO, FAISAL (KTPNAN)` has 73064 (69.1%) zeros	Zeros
`MONTEMAYOR, JOSE JR. (DPP)` has 66565 (63.0%) zeros	Zeros
`PACQUIAO, MANNY PACMAN(PROMDI)` has 4461 (4.2%) zeros	Zeros

Reproduction

Analysis started	2022-05-20 01:09:18.534453
Analysis finished	2022-05-20 01:09:40.610629
Duration	22.08 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

Region
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	825.6 KiB

REGION IV-A	13906
REGION III	10853
NATIONAL CAPITAL REGION	10388
REGION VI	8558
REGION VII	8019
Other values (13)	53942

Length

Max length	32
Median length	11
Mean length	11.19338292
Min length	3

Characters and Unicode

Total characters	1182760
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	REGION X
2nd row	REGION X
3rd row	REGION X
4th row	REGION X
5th row	REGION X

Common Values

Value	Count	Frequency (%)
REGION IV-A	13906	13.2%
REGION III	10853	10.3%
NATIONAL CAPITAL REGION	10388	9.8%
REGION VI	8558	8.1%
REGION VII	8019	7.6%
REGION V	6653	6.3%
REGION VIII	6255	5.9%
REGION I	6117	5.8%
REGION X	4933	4.7%
REGION XI	4762	4.5%
Other values (8)	25222	23.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
region	100786	46.0%
iv-a	13906	6.4%
iii	10853	5.0%
national	10388	4.7%
capital	10388	4.7%
vi	8558	3.9%
vii	8019	3.7%
v	6653	3.0%
viii	6255	2.9%
i	6117	2.8%
Other values (11)	37063	16.9%

Most occurring characters

Value	Count	Frequency (%)
I	263141	22.2%
N	123708	10.5%
O	114181	9.7%
	113320	9.6%
R	111243	9.4%
E	105078	8.9%
G	100786	8.5%
A	66776	5.6%
V	49735	4.2%
T	25068	2.1%
Other values (9)	109724	9.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1052197	89.0%
Space Separator	113320	9.6%
Dash Punctuation	17243	1.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	263141	25.0%
N	123708	11.8%
O	114181	10.9%
R	111243	10.6%
E	105078	10.0%
G	100786	9.6%
A	66776	6.3%
V	49735	4.7%
T	25068	2.4%
L	25068	2.4%
Other values (7)	67413	6.4%

Space Separator

Value	Count	Frequency (%)
	113320	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	17243	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1052197	89.0%
Common	130563	11.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	263141	25.0%
N	123708	11.8%
O	114181	10.9%
R	111243	10.6%
E	105078	10.0%
G	100786	9.6%
A	66776	6.3%
V	49735	4.7%
T	25068	2.4%
L	25068	2.4%
Other values (7)	67413	6.4%

Common

Value	Count	Frequency (%)
	113320	86.8%
-	17243	13.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1182760	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	263141	22.2%
N	123708	10.5%
O	114181	9.7%
	113320	9.6%
R	111243	9.4%
E	105078	8.9%
G	100786	8.5%
A	66776	5.6%
V	49735	4.2%
T	25068	2.1%
Other values (9)	109724	9.3%

Province
Categorical

HIGH CARDINALITY
HIGH CORRELATION
HIGH CORRELATION

Distinct	90
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	825.6 KiB

CEBU	4692
CAVITE	3371
NCR - SECOND DISTRICT	3354
PANGASINAN	3330
ILOILO	3058
Other values (85)	87861

Length

Max length	23
Median length	18
Mean length	10.4854447
Min length	4

Characters and Unicode

Total characters	1107955
Distinct characters	27
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	BUKIDNON
2nd row	BUKIDNON
3rd row	BUKIDNON
4th row	BUKIDNON
5th row	BUKIDNON

Common Values

Value	Count	Frequency (%)
CEBU	4692	4.4%
CAVITE	3371	3.2%
NCR - SECOND DISTRICT	3354	3.2%
PANGASINAN	3330	3.2%
ILOILO	3058	2.9%
LAGUNA	2958	2.8%
NEGROS OCCIDENTAL	2901	2.7%
BATANGAS	2855	2.7%
BULACAN	2835	2.7%
LEYTE	2535	2.4%
Other values (80)	73777	69.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
del	11004	6.0%
	10388	5.7%
ncr	9705	5.3%
sur	9611	5.3%
district	7922	4.3%
norte	6032	3.3%
davao	4762	2.6%
cebu	4692	2.6%
oriental	4583	2.5%
occidental	4510	2.5%
Other values (87)	109402	59.9%

Most occurring characters

Value	Count	Frequency (%)
A	158824	14.3%
N	95597	8.6%
	76945	6.9%
O	75327	6.8%
I	74901	6.8%
E	71281	6.4%
R	69040	6.2%
T	63829	5.8%
S	61162	5.5%
L	56735	5.1%
Other values (17)	304314	27.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1020222	92.1%
Space Separator	76945	6.9%
Dash Punctuation	10788	1.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	158824	15.6%
N	95597	9.4%
O	75327	7.4%
I	74901	7.3%
E	71281	7.0%
R	69040	6.8%
T	63829	6.3%
S	61162	6.0%
L	56735	5.6%
C	56670	5.6%
Other values (15)	236856	23.2%

Space Separator

Value	Count	Frequency (%)
	76945	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	10788	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1020222	92.1%
Common	87733	7.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	158824	15.6%
N	95597	9.4%
O	75327	7.4%
I	74901	7.3%
E	71281	7.0%
R	69040	6.8%
T	63829	6.3%
S	61162	6.0%
L	56735	5.6%
C	56670	5.6%
Other values (15)	236856	23.2%

Common

Value	Count	Frequency (%)
	76945	87.7%
-	10788	12.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1107955	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	158824	14.3%
N	95597	8.6%
	76945	6.9%
O	75327	6.8%
I	74901	6.8%
E	71281	6.4%
R	69040	6.2%
T	63829	5.8%
S	61162	5.5%
L	56735	5.1%
Other values (17)	304314	27.5%

City
Categorical

HIGH CARDINALITY

Distinct	1441
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Memory size	825.6 KiB

QUEZON CITY	1904
CITY OF DAVAO	1345
CITY OF CALOOCAN	1018
CITY OF CEBU	909
CITY OF ANTIPOLO	650
Other values (1436)	99840

Length

Max length	31
Median length	23
Mean length	10.33283175
Min length	3

Characters and Unicode

Total characters	1091829
Distinct characters	31
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	BAUNGON
2nd row	BAUNGON
3rd row	BAUNGON
4th row	BAUNGON
5th row	BAUNGON

Common Values

Value	Count	Frequency (%)
QUEZON CITY	1904	1.8%
CITY OF DAVAO	1345	1.3%
CITY OF CALOOCAN	1018	1.0%
CITY OF CEBU	909	0.9%
CITY OF ANTIPOLO	650	0.6%
TONDO	628	0.6%
CITY OF ZAMBOANGA	625	0.6%
CITY OF TAGUIG	622	0.6%
SANTA CRUZ	622	0.6%
CITY OF MAKATI	615	0.6%
Other values (1431)	96728	91.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
city	34593	17.9%
of	31745	16.5%
san	6391	3.3%
santa	2488	1.3%
quezon	2189	1.1%
davao	1345	0.7%
jose	1141	0.6%
general	1037	0.5%
caloocan	1018	0.5%
cebu	909	0.5%
Other values (1477)	110059	57.1%

Most occurring characters

Value	Count	Frequency (%)
A	176629	16.2%
O	95041	8.7%
	87249	8.0%
I	85577	7.8%
N	80575	7.4%
T	68087	6.2%
C	61058	5.6%
L	48878	4.5%
Y	46773	4.3%
S	40753	3.7%
Other values (21)	301209	27.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1002432	91.8%
Space Separator	87249	8.0%
Other Punctuation	1086	0.1%
Dash Punctuation	1062	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	176629	17.6%
O	95041	9.5%
I	85577	8.5%
N	80575	8.0%
T	68087	6.8%
C	61058	6.1%
L	48878	4.9%
Y	46773	4.7%
S	40753	4.1%
U	34595	3.5%
Other values (17)	264466	26.4%

Other Punctuation

Value	Count	Frequency (%)
.	815	75.0%
'	271	25.0%

Space Separator

Value	Count	Frequency (%)
	87249	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1062	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1002432	91.8%
Common	89397	8.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	176629	17.6%
O	95041	9.5%
I	85577	8.5%
N	80575	8.0%
T	68087	6.8%
C	61058	6.1%
L	48878	4.9%
Y	46773	4.7%
S	40753	4.1%
U	34595	3.5%
Other values (17)	264466	26.4%

Common

Value	Count	Frequency (%)
	87249	97.6%
-	1062	1.2%
.	815	0.9%
'	271	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1089451	99.8%
None	2378	0.2%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	176629	16.2%
O	95041	8.7%
	87249	8.0%
I	85577	7.9%
N	80575	7.4%
T	68087	6.2%
C	61058	5.6%
L	48878	4.5%
Y	46773	4.3%
S	40753	3.7%
Other values (20)	298831	27.4%

None

Value	Count	Frequency (%)
Ñ	2378	100.0%

Barangay
Categorical

HIGH CARDINALITY

Distinct	26279
Distinct (%)	24.9%
Missing	0
Missing (%)	0.0%
Memory size	825.6 KiB

POBLACION	2914
SAN ISIDRO	977
SAN JOSE	681
SAN ROQUE	526
SAN VICENTE	504
Other values (26274)	100064

Length

Max length	45
Median length	39
Mean length	9.533492325
Min length	2

Characters and Unicode

Total characters	1007366
Distinct characters	46
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9611 ?
Unique (%)	9.1%

Sample

1st row	BALINTAD
2nd row	BUENAVISTA
3rd row	DANATAG
4th row	DANATAG
5th row	DANATAG

Common Values

Value	Count	Frequency (%)
POBLACION	2914	2.8%
SAN ISIDRO	977	0.9%
SAN JOSE	681	0.6%
SAN ROQUE	526	0.5%
SAN VICENTE	504	0.5%
SAN ANTONIO	500	0.5%
SAN JUAN	467	0.4%
SANTO NIÑO	438	0.4%
SANTA CRUZ	387	0.4%
SAN MIGUEL	336	0.3%
Other values (26269)	97936	92.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
san	8568	5.5%
pob	7750	4.9%
barangay	5810	3.7%
poblacion	4755	3.0%
santa	2016	1.3%
i	1238	0.8%
ii	1228	0.8%
santo	1196	0.8%
isidro	1171	0.7%
jose	1041	0.7%
Other values (21493)	122244	77.9%

Most occurring characters

Value	Count	Frequency (%)
A	187602	18.6%
N	100132	9.9%
O	74255	7.4%
I	62394	6.2%
	51598	5.1%
B	50238	5.0%
L	48571	4.8%
G	45908	4.6%
S	43194	4.3%
T	36930	3.7%
Other values (36)	306544	30.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	910233	90.4%
Space Separator	54542	5.4%
Decimal Number	13496	1.3%
Other Punctuation	9777	1.0%
Open Punctuation	7308	0.7%
Close Punctuation	7308	0.7%
Dash Punctuation	4702	0.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	187602	20.6%
N	100132	11.0%
O	74255	8.2%
I	62394	6.9%
B	50238	5.5%
L	48571	5.3%
G	45908	5.0%
S	43194	4.7%
T	36930	4.1%
R	34263	3.8%
Other values (17)	226746	24.9%

Decimal Number

Value	Count	Frequency (%)
1	2888	21.4%
2	1621	12.0%
7	1359	10.1%
3	1345	10.0%
6	1270	9.4%
8	1173	8.7%
4	1145	8.5%
5	1132	8.4%
9	815	6.0%
0	748	5.5%

Other Punctuation

Value	Count	Frequency (%)
.	9711	99.3%
'	56	0.6%
/	8	0.1%
*	2	< 0.1%

Space Separator

Value	Count	Frequency (%)
	51598	94.6%
	2944	5.4%

Open Punctuation

Value	Count	Frequency (%)
(	7308	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	7308	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	4702	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	910233	90.4%
Common	97133	9.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	187602	20.6%
N	100132	11.0%
O	74255	8.2%
I	62394	6.9%
B	50238	5.5%
L	48571	5.3%
G	45908	5.0%
S	43194	4.7%
T	36930	4.1%
R	34263	3.8%
Other values (17)	226746	24.9%

Common

Value	Count	Frequency (%)
	51598	53.1%
.	9711	10.0%
(	7308	7.5%
)	7308	7.5%
-	4702	4.8%
	2944	3.0%
1	2888	3.0%
2	1621	1.7%
7	1359	1.4%
3	1345	1.4%
Other values (9)	6349	6.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1003311	99.6%
None	4055	0.4%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	187602	18.7%
N	100132	10.0%
O	74255	7.4%
I	62394	6.2%
	51598	5.1%
B	50238	5.0%
L	48571	4.8%
G	45908	4.6%
S	43194	4.3%
T	36930	3.7%
Other values (34)	302489	30.1%

None

Value	Count	Frequency (%)
	2944	72.6%
Ñ	1111	27.4%

Precinct ID
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	105666
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	41654134.65

Minimum	1010001
Maximum	93150021
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	825.6 KiB

Quantile statistics

Minimum	1010001
5-th percentile	7120015.25
Q1	22170748.25
median	39141465.5
Q3	58130083.75
95-th percentile	76050121.75
Maximum	93150021
Range	92140020
Interquartile range (IQR)	35959335.5

Descriptive statistics

Standard deviation	22775840.69
Coefficient of variation (CV)	0.546784632
Kurtosis	-1.078557382
Mean	41654134.65
Median Absolute Deviation (MAD)	17941405
Skewness	0.1373227102
Sum	4.401425792 × 10¹²
Variance	5.187389189 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13010009	1	< 0.1%
92010025	1	< 0.1%
92010103	1	< 0.1%
92010102	1	< 0.1%
92010101	1	< 0.1%
92010087	1	< 0.1%
92010070	1	< 0.1%
92010069	1	< 0.1%
92010068	1	< 0.1%
92010050	1	< 0.1%
Other values (105656)	105656	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1010001	1	< 0.1%
1010002	1	< 0.1%
1010003	1	< 0.1%
1010004	1	< 0.1%
1010005	1	< 0.1%
1010006	1	< 0.1%
1010007	1	< 0.1%
1010008	1	< 0.1%
1010009	1	< 0.1%
1010010	1	< 0.1%

Value	Count	Frequency (%)
93150021	1	< 0.1%
93150020	1	< 0.1%
93150019	1	< 0.1%
93150018	1	< 0.1%
93150017	1	< 0.1%
93150016	1	< 0.1%
93150015	1	< 0.1%
93150014	1	< 0.1%
93150010	1	< 0.1%
93150008	1	< 0.1%

ABELLA, ERNIE (IND)
Real number (ℝ_≥0)

ZEROS

Distinct	28
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.069568262

Minimum	0
Maximum	33
Zeros	47643
Zeros (%)	45.1%
Negative	0
Negative (%)	0.0%
Memory size	825.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	4
Maximum	33
Range	33
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.452748253
Coefficient of variation (CV)	1.358256695
Kurtosis	17.9236327
Mean	1.069568262
Median Absolute Deviation (MAD)	1
Skewness	2.780923701
Sum	113017
Variance	2.110477487
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
0	47643	45.1%
1	30056	28.4%
2	14742	14.0%
3	6801	6.4%
4	3214	3.0%
5	1537	1.5%
6	760	0.7%
7	366	0.3%
8	212	0.2%
9	133	0.1%
Other values (18)	202	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	47643	45.1%
1	30056	28.4%
2	14742	14.0%
3	6801	6.4%
4	3214	3.0%
5	1537	1.5%
6	760	0.7%
7	366	0.3%
8	212	0.2%
9	133	0.1%

Value	Count	Frequency (%)
33	1	< 0.1%
29	1	< 0.1%
26	1	< 0.1%
25	2	< 0.1%
23	3	< 0.1%
22	1	< 0.1%
21	1	< 0.1%
20	1	< 0.1%
19	2	< 0.1%
18	4	< 0.1%

DE GUZMAN, LEODY (PLM)
Real number (ℝ_≥0)

ZEROS

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.869702648

Minimum	0
Maximum	66
Zeros	50828
Zeros (%)	48.1%
Negative	0
Negative (%)	0.0%
Memory size	825.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	1
95-th percentile	3
Maximum	66
Range	66
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.204040839
Coefficient of variation (CV)	1.384428163
Kurtosis	203.391695
Mean	0.869702648
Median Absolute Deviation (MAD)	1
Skewness	6.42667231
Sum	91898
Variance	1.449714343
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
0	50828	48.1%
1	32125	30.4%
2	14210	13.4%
3	5377	5.1%
4	1941	1.8%
5	667	0.6%
6	257	0.2%
7	124	0.1%
8	48	< 0.1%
9	21	< 0.1%
Other values (21)	68	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	50828	48.1%
1	32125	30.4%
2	14210	13.4%
3	5377	5.1%
4	1941	1.8%
5	667	0.6%
6	257	0.2%
7	124	0.1%
8	48	< 0.1%
9	21	< 0.1%

Value	Count	Frequency (%)
66	1	< 0.1%
58	1	< 0.1%
51	1	< 0.1%
41	1	< 0.1%
34	2	< 0.1%
32	1	< 0.1%
30	1	< 0.1%
27	2	< 0.1%
26	1	< 0.1%
24	1	< 0.1%

DOMAGOSO, ISKO MORENO (AKSYON)
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	319
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.84268355

Minimum	0
Maximum	351
Zeros	4429
Zeros (%)	4.2%
Negative	0
Negative (%)	0.0%
Memory size	825.6 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	5
median	12
Q3	23
95-th percentile	43
Maximum	351
Range	351
Interquartile range (IQR)	18

Descriptive statistics

Standard deviation	24.39606704
Coefficient of variation (CV)	1.367286876
Kurtosis	45.97286638
Mean	17.84268355
Median Absolute Deviation (MAD)	8
Skewness	5.73448762
Sum	1885365
Variance	595.1680871
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	4738	4.5%
2	4687	4.4%
4	4600	4.4%
5	4589	4.3%
0	4429	4.2%
1	4397	4.2%
6	4192	4.0%
7	4074	3.9%
8	3825	3.6%
9	3683	3.5%
Other values (309)	62452	59.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4429	4.2%
1	4397	4.2%
2	4687	4.4%
3	4738	4.5%
4	4600	4.4%
5	4589	4.3%
6	4192	4.0%
7	4074	3.9%
8	3825	3.6%
9	3683	3.5%

Value	Count	Frequency (%)
351	1	< 0.1%
347	1	< 0.1%
345	1	< 0.1%
340	1	< 0.1%
339	1	< 0.1%
334	2	< 0.1%
333	1	< 0.1%
329	2	< 0.1%
328	2	< 0.1%
325	1	< 0.1%

GONZALES, NORBERTO (PDSP)
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	22
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.8408475763

Minimum	0
Maximum	197
Zeros	52143
Zeros (%)	49.3%
Negative	0
Negative (%)	0.0%
Memory size	825.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	1
95-th percentile	3
Maximum	197
Range	197
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.349179798
Coefficient of variation (CV)	1.604547407
Kurtosis	5161.257074
Mean	0.8408475763
Median Absolute Deviation (MAD)	1
Skewness	40.24535664
Sum	88849
Variance	1.820286128
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
0	52143	49.3%
1	31995	30.3%
2	13471	12.7%
3	5064	4.8%
4	1775	1.7%
5	699	0.7%
6	264	0.2%
7	121	0.1%
8	56	0.1%
9	22	< 0.1%
Other values (12)	56	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	52143	49.3%
1	31995	30.3%
2	13471	12.7%
3	5064	4.8%
4	1775	1.7%
5	699	0.7%
6	264	0.2%
7	121	0.1%
8	56	0.1%
9	22	< 0.1%

Value	Count	Frequency (%)
197	1	< 0.1%
134	1	< 0.1%
57	1	< 0.1%
28	1	< 0.1%
23	2	< 0.1%
18	2	< 0.1%
15	2	< 0.1%
14	3	< 0.1%
13	9	< 0.1%
12	8	< 0.1%

LACSON, PING (PDR)
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	128
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.332737115

Minimum	0
Maximum	225
Zeros	9080
Zeros (%)	8.6%
Negative	0
Negative (%)	0.0%
Memory size	825.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	6
Q3	12
95-th percentile	23
Maximum	225
Range	225
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	8.616097119
Coefficient of variation (CV)	1.034005633
Kurtosis	37.6584202
Mean	8.332737115
Median Absolute Deviation (MAD)	4
Skewness	3.598687374
Sum	880487
Variance	74.23712957
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9080	8.6%
1	8908	8.4%
2	8782	8.3%
3	8144	7.7%
4	7592	7.2%
5	6744	6.4%
6	6116	5.8%
7	5491	5.2%
8	5001	4.7%
9	4613	4.4%
Other values (118)	35195	33.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9080	8.6%
1	8908	8.4%
2	8782	8.3%
3	8144	7.7%
4	7592	7.2%
5	6744	6.4%
6	6116	5.8%
7	5491	5.2%
8	5001	4.7%
9	4613	4.4%

Value	Count	Frequency (%)
225	1	< 0.1%
218	1	< 0.1%
215	1	< 0.1%
212	1	< 0.1%
202	1	< 0.1%
193	1	< 0.1%
166	1	< 0.1%
164	1	< 0.1%
160	1	< 0.1%
145	1	< 0.1%

MANGONDATO, FAISAL (KTPNAN)
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	329
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.409034126

Minimum	0
Maximum	573
Zeros	73064
Zeros (%)	69.1%
Negative	0
Negative (%)	0.0%
Memory size	825.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	5
Maximum	573
Range	573
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	17.3092104
Coefficient of variation (CV)	7.185124617
Kurtosis	218.0171413
Mean	2.409034126
Median Absolute Deviation (MAD)	0
Skewness	13.28802573
Sum	254553
Variance	299.6087648
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	73064	69.1%
1	19366	18.3%
2	5054	4.8%
3	1804	1.7%
4	947	0.9%
5	735	0.7%
6	545	0.5%
7	409	0.4%
8	348	0.3%
10	284	0.3%
Other values (319)	3110	2.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	73064	69.1%
1	19366	18.3%
2	5054	4.8%
3	1804	1.7%
4	947	0.9%
5	735	0.7%
6	545	0.5%
7	409	0.4%
8	348	0.3%
9	281	0.3%

Value	Count	Frequency (%)
573	1	< 0.1%
563	1	< 0.1%
529	1	< 0.1%
495	1	< 0.1%
461	1	< 0.1%
453	1	< 0.1%
451	1	< 0.1%
443	1	< 0.1%
441	1	< 0.1%
436	1	< 0.1%

MARCOS, BONGBONG (PFP)
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	851
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	293.5840289

Minimum	0
Maximum	1105
Zeros	378
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	825.6 KiB

Quantile statistics

Minimum	0
5-th percentile	55
Q1	191
median	304
Q3	392
95-th percentile	510.75
Maximum	1105
Range	1105
Interquartile range (IQR)	201

Descriptive statistics

Standard deviation	138.8758545
Coefficient of variation (CV)	0.4730361356
Kurtosis	-0.2828640695
Mean	293.5840289
Median Absolute Deviation (MAD)	98
Skewness	0.006904603536
Sum	31021850
Variance	19286.50297
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	378	0.4%
345	355	0.3%
364	339	0.3%
378	339	0.3%
376	337	0.3%
343	329	0.3%
352	325	0.3%
356	324	0.3%
340	323	0.3%
363	322	0.3%
Other values (841)	102295	96.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	378	0.4%
1	41	< 0.1%
2	24	< 0.1%
3	33	< 0.1%
4	27	< 0.1%
5	42	< 0.1%
6	37	< 0.1%
7	48	< 0.1%
8	42	< 0.1%
9	48	< 0.1%

Value	Count	Frequency (%)
1105	1	< 0.1%
1080	1	< 0.1%
1039	1	< 0.1%
1026	1	< 0.1%
1013	1	< 0.1%
1012	1	< 0.1%
964	1	< 0.1%
962	1	< 0.1%
940	1	< 0.1%
934	1	< 0.1%

MONTEMAYOR, JOSE JR. (DPP)
Real number (ℝ_≥0)

ZEROS

Distinct	28
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.5661707645

Minimum	0
Maximum	37
Zeros	66565
Zeros (%)	63.0%
Negative	0
Negative (%)	0.0%
Memory size	825.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	2
Maximum	37
Range	37
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.013811002
Coefficient of variation (CV)	1.790645271
Kurtosis	92.06014422
Mean	0.5661707645
Median Absolute Deviation (MAD)	0
Skewness	5.415641258
Sum	59825
Variance	1.027812748
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
0	66565	63.0%
1	26414	25.0%
2	8408	8.0%
3	2635	2.5%
4	909	0.9%
5	339	0.3%
6	148	0.1%
7	89	0.1%
8	42	< 0.1%
9	30	< 0.1%
Other values (18)	87	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	66565	63.0%
1	26414	25.0%
2	8408	8.0%
3	2635	2.5%
4	909	0.9%
5	339	0.3%
6	148	0.1%
7	89	0.1%
8	42	< 0.1%
9	30	< 0.1%

Value	Count	Frequency (%)
37	1	< 0.1%
34	2	< 0.1%
32	1	< 0.1%
30	1	< 0.1%
29	1	< 0.1%
24	1	< 0.1%
23	2	< 0.1%
20	2	< 0.1%
19	1	< 0.1%
18	5	< 0.1%

PACQUIAO, MANNY PACMAN(PROMDI)
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	457
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34.31038366

Minimum	0
Maximum	615
Zeros	4461
Zeros (%)	4.2%
Negative	0
Negative (%)	0.0%
Memory size	825.6 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	6
median	14
Q3	41
95-th percentile	140
Maximum	615
Range	615
Interquartile range (IQR)	35

Descriptive statistics

Standard deviation	51.21611708
Coefficient of variation (CV)	1.492729361
Kurtosis	12.30610517
Mean	34.31038366
Median Absolute Deviation (MAD)	11
Skewness	3.050595529
Sum	3625441
Variance	2623.090648
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4461	4.2%
5	4170	3.9%
3	4129	3.9%
6	4127	3.9%
7	4063	3.8%
4	4051	3.8%
2	3957	3.7%
8	3867	3.7%
1	3754	3.6%
9	3664	3.5%
Other values (447)	65423	61.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4461	4.2%
1	3754	3.6%
2	3957	3.7%
3	4129	3.9%
4	4051	3.8%
5	4170	3.9%
6	4127	3.9%
7	4063	3.8%
8	3867	3.7%
9	3664	3.5%

Value	Count	Frequency (%)
615	1	< 0.1%
614	1	< 0.1%
564	1	< 0.1%
554	1	< 0.1%
537	1	< 0.1%
533	1	< 0.1%
530	1	< 0.1%
516	1	< 0.1%
510	1	< 0.1%
508	1	< 0.1%

ROBREDO, LENI (IND)
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	667
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	139.9256147

Minimum	0
Maximum	790
Zeros	900
Zeros (%)	0.9%
Negative	0
Negative (%)	0.0%
Memory size	825.6 KiB

Quantile statistics

Minimum	0
5-th percentile	12
Q1	52
median	121
Q3	195
95-th percentile	357
Maximum	790
Range	790
Interquartile range (IQR)	143

Descriptive statistics

Standard deviation	110.3764064
Coefficient of variation (CV)	0.7888220229
Kurtosis	1.883229974
Mean	139.9256147
Median Absolute Deviation (MAD)	71
Skewness	1.253556496
Sum	14785380
Variance	12182.95109
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	900	0.9%
25	631	0.6%
26	617	0.6%
36	587	0.6%
38	583	0.6%
40	581	0.5%
23	578	0.5%
24	566	0.5%
33	563	0.5%
30	561	0.5%
Other values (657)	99499	94.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	900	0.9%
1	304	0.3%
2	320	0.3%
3	317	0.3%
4	362	0.3%
5	358	0.3%
6	406	0.4%
7	355	0.3%
8	401	0.4%
9	390	0.4%

Value	Count	Frequency (%)
790	1	< 0.1%
744	1	< 0.1%
743	1	< 0.1%
735	1	< 0.1%
732	1	< 0.1%
728	1	< 0.1%
727	1	< 0.1%
718	2	< 0.1%
699	1	< 0.1%
698	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	Region	Province	City	Barangay	Precinct ID	ABELLA, ERNIE (IND)	DE GUZMAN, LEODY (PLM)	DOMAGOSO, ISKO MORENO (AKSYON)	GONZALES, NORBERTO (PDSP)	LACSON, PING (PDR)	MANGONDATO, FAISAL (KTPNAN)	MARCOS, BONGBONG (PFP)	MONTEMAYOR, JOSE JR. (DPP)	PACQUIAO, MANNY PACMAN(PROMDI)	ROBREDO, LENI (IND)
0	REGION X	BUKIDNON	BAUNGON	BALINTAD	13010009	2	1	4	0	0	1	224	0	115	29
1	REGION X	BUKIDNON	BAUNGON	BUENAVISTA	13010010	3	5	7	5	0	2	310	1	188	47
2	REGION X	BUKIDNON	BAUNGON	DANATAG	13010011	4	3	9	4	3	0	288	4	152	44
3	REGION X	BUKIDNON	BAUNGON	DANATAG	13010012	2	2	16	2	3	0	190	3	160	51
4	REGION X	BUKIDNON	BAUNGON	DANATAG	13010013	0	1	16	4	6	0	272	2	125	46
5	REGION X	BUKIDNON	BAUNGON	KALILANGAN	13010014	6	0	10	1	3	1	320	0	140	50
6	REGION X	BUKIDNON	BAUNGON	LACOLAC	13010015	3	1	5	1	5	1	275	1	151	62
7	REGION X	BUKIDNON	BAUNGON	LANGAON	13010016	1	0	4	0	0	1	157	1	146	41
8	REGION X	BUKIDNON	BAUNGON	LANGAON	13010017	1	2	3	1	3	1	174	1	131	36
9	REGION X	BUKIDNON	BAUNGON	LIBORAN	13010018	5	4	6	2	4	0	266	1	235	51

Last rows

	Region	Province	City	Barangay	Precinct ID	ABELLA, ERNIE (IND)	DE GUZMAN, LEODY (PLM)	DOMAGOSO, ISKO MORENO (AKSYON)	GONZALES, NORBERTO (PDSP)	LACSON, PING (PDR)	MANGONDATO, FAISAL (KTPNAN)	MARCOS, BONGBONG (PFP)	MONTEMAYOR, JOSE JR. (DPP)	PACQUIAO, MANNY PACMAN(PROMDI)	ROBREDO, LENI (IND)
105656	REGION III	BATAAN	SAMAL	TABING ILOG	8120009	0	0	46	1	7	0	367	0	1	99
105657	REGION III	BATAAN	SAMAL	GUGO	8120014	3	1	25	0	21	0	366	0	11	103
105658	REGION III	BATAAN	SAMAL	GUGO	8120015	4	1	50	0	8	0	433	0	11	87
105659	REGION III	BATAAN	SAMAL	GUGO	8120016	5	5	47	0	9	1	413	0	12	83
105660	REGION III	BATAAN	SAMAL	GUGO	8120017	1	1	44	1	6	0	364	0	14	124
105661	REGION III	BATAAN	SAMAL	GUGO	8120018	3	0	38	0	7	0	347	1	12	124
105662	REGION III	BATAAN	SAMAL	WEST CALAGUIMAN (POB.)	8120049	2	0	58	2	5	1	243	0	7	197
105663	REGION III	BATAAN	SAMAL	WEST CALAGUIMAN (POB.)	8120050	0	0	37	1	10	0	233	1	5	236
105664	REGION III	BATAAN	SAMAL	WEST DAANG BAGO (POB.)	8120003	3	1	20	2	11	0	194	0	9	127
105665	REGION III	BATAAN	SAMAL	WEST DAANG BAGO (POB.)	8120004	1	0	26	2	12	0	215	0	2	138

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Open Punctuation

Close Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values

Sample

First rows

Last rows